<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ page import="java.util.Date" %>
<%@include file="/include/common/reportbackhead.jsp"%>
<%!
private class PageAction extends BaseAction{
	ResultSet rs = null;
	
	//加載頁面默認數據
	protected boolean onLoadDefault() throws Exception {
		SimpleDateFormat df = new SimpleDateFormat("yyyy/MM/dd hh:dd");
		form.SetParamValue("printdate",df.format(new Date()));
		onSearch();
		return true;
	}	
	
	protected void onSearchRetrieveResult() throws Exception{
		//加載報表的主數據源	
		rs = utils.executeQuery("info5","select distinct billNo,orderno,hrNum,dh_no,sqty from("+
		" select billNo,orderno,hrNum,dh_no,gx_no,SUM(sqty) as sqty from mf..jj003 where convert(nvarchar(10),crtDay,111)='2012/02/25' group by billNo,orderno,hrNum,dh_no,gx_no) k"+
		" order by hrNum,billNo,dh_no"+
		" ");
		ret.SetSearchResult(rs);
	}
}
%>
<%@include file="/include/common/reportbackend.jsp"%>